<?php

/**
 * Application model for Cake.
 *
 * This file is application-wide model file. You can put all
 * application-wide model-related methods here.
 *
 * PHP 5
 *
 * CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
 * Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
 *
 * Licensed under The MIT License
 * For full copyright and license information, please see the LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright     Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)
 * @link          http://cakephp.org CakePHP(tm) Project
 * @package       app.Model
 * @since         CakePHP(tm) v 0.2.9
 * @license       MIT License (http://www.opensource.org/licenses/mit-license.php)
 */
App::uses('Model', 'Model');

/**
 * Application model for Cake.
 *
 * Add your application-wide methods in the class below, your models
 * will inherit them.
 *
 * @package       app.Model
 */
class AppModel extends Model {

    /**
     * Monta o combo
     * @param array $indexs
     * @return array 
     */
    public function getCombo(array $indexs) 
    {
        $query = "SELECT DISTINCT ". implode(',', $indexs) ."  FROM {$this->table} ORDER BY 2 ASC";
        $resultList = $this->query($query);
        
        $arrResult = array('' => 'Selecione um item');

        foreach ($resultList as $table) {
            foreach ($table as $list) {
                
                $arrResult[$list[$indexs[0]]] = $list[$indexs[1]];
            }
        }
        
        return $arrResult;
    }

    public function nextVal($id)
    {        
        $query = "SELECT MAX({$id}) as {$id} FROM {$this->table}";
        $value = $this->query($query);
        return $value[0][0][$id] + 1;
    }
}
